delete from role_auth where AUTH_TYPE = 10
go

--一线员工积分台帐的确认同意
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (10,3,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (10,4,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (10,5,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (10,6,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (10,8,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (10,9,1,1)
go
--一线员工积分台帐的上报
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (10,2,3,1)
go

--管理员工积分台帐的确认同意
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (11,2,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (11,3,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (11,4,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (11,5,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (11,6,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (11,8,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (11,9,1,1)
go

insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (11,10,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (11,11,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (11,12,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (11,13,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (11,14,1,1)
go
--管理员工积分台帐无需上报

--单位积分台帐的确认同意
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,5,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,6,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,8,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,9,1,1)
go

insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,13,1,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,14,1,1)
go
--单位积分台帐的上报
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,2,3,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,3,3,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,4,3,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,5,3,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,6,3,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,8,3,1)
go

insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,10,3,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,11,3,1)
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (12,12,3,1)
go